UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6TSZ1WaRnbyq+KkasE6a+OM97HiflCKjTK8Wct9KaTg='
WHERE
key_id = 'a5165964e8e23880d0fbb555a403dbee2dfd291b0937e0234cee3b41b45e8faa'
AND (
token = '6TSZ1WaRnbyq+KkasE6a+OM97HiflCKjTK8Wct9KaTg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)