UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xohs8nPIn/HsGu+8i1ToPvdluws0J2ukVXhbAdeZ8EA='
WHERE
key_id = 'f42dc4824fea4084b9b96acc211b6c813c7de629848e38ecbdc681c591e3a4a3'
AND (
token = 'Xohs8nPIn/HsGu+8i1ToPvdluws0J2ukVXhbAdeZ8EA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)