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