UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XcTd8kTEd++K10gKKwk0V6aaryrNv7EC26fSTeuVsMg='
WHERE
key_id = 'c923144aa166b0f02ecab4367f266adb1efb2b4ff4059f07b136b5406c73f87a'
AND (
token = 'XcTd8kTEd++K10gKKwk0V6aaryrNv7EC26fSTeuVsMg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)