UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hAoTLcCcQxdl4d1uYNdR5825k94e6ck82fUwcHqcny4='
WHERE
key_id = '7a59fab64f31740747526274bf0a71df17f46d3cda980b24785e8615b37ba338'
AND (
token = 'hAoTLcCcQxdl4d1uYNdR5825k94e6ck82fUwcHqcny4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)