UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9cFu59wz8QoWNUoSFZSJmsFPkGXWdq1AjcfT5pbbCsA='
WHERE
key_id = 'cb2a1f96b79aa418e310f8bf1f3d0f5568f7afef04ea23ef337fa7e1bfca7177'
AND (
token = '9cFu59wz8QoWNUoSFZSJmsFPkGXWdq1AjcfT5pbbCsA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)