UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'i6YMjTVHMSFFUOnd2TVBzdjichTLC5TbT64RFrPqFV4='
WHERE
key_id = '37d43ca27fc4dccfdddb1a387ad6b3fa3526a900b6ed4a7eaba094ea58bd78db'
AND (
token = 'i6YMjTVHMSFFUOnd2TVBzdjichTLC5TbT64RFrPqFV4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)