UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SpcQ3CJpas43XcDbUjviJJ4WYAmVURDGSyMiphRT794='
WHERE
key_id = 'bb169f4ce4cc79d0f45a37325a05b0c5fb25e7f11711ceae7560d9cc2dc6cf94'
AND (
token = 'SpcQ3CJpas43XcDbUjviJJ4WYAmVURDGSyMiphRT794='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)