UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '31BbfL36IHn1qK6fjjAMqJy9NtRlKwshMWLAt9FR4zs='
WHERE
key_id = 'd89b9c0bd7f13a9a89ccb934e972fe97990150905a7c5d9bf5227588ca3ba6e9'
AND (
token = '31BbfL36IHn1qK6fjjAMqJy9NtRlKwshMWLAt9FR4zs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)