UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'UzMzziWbCXmzCI4w5ya3P2Y2bojBsxLFGhHVLkC4Cio='
WHERE
key_id = '9586d2c39ed2ca4039ad33fedc8fd3605f59a16d9b9e9b5ad3b6abbab84e5847'
AND (
token = 'UzMzziWbCXmzCI4w5ya3P2Y2bojBsxLFGhHVLkC4Cio='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)