UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LPi6MTY3SyMsECDSKULXCaDS2WYhdF0V5q1eBARwHrY='
WHERE
key_id = '00bac3a978c68a1de064b30e9f2e2becf7271ff900ea565d941d41fd21954522'
AND (
token = 'LPi6MTY3SyMsECDSKULXCaDS2WYhdF0V5q1eBARwHrY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)