UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sd9bsWgu2r0YVYYaSdJbTic74WmQYgP60SAav1A4EKQ='
WHERE
key_id = 'bebcab1b8466977773fc99ab7f43fcd55f0c4bfc4c3215e326aca73929198b46'
AND (
token = 'sd9bsWgu2r0YVYYaSdJbTic74WmQYgP60SAav1A4EKQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)