UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UX24XrGCNZrp0PXgCXcxv+wNWiYCgBE0Tud9yfSpMWY='
WHERE
key_id = 'b49f6c26a377939dd0d094898ad3c50f81de500fbaa560f499ded61cd6cf9485'
AND (
token = 'UX24XrGCNZrp0PXgCXcxv+wNWiYCgBE0Tud9yfSpMWY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)