UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1UxIpg8uBbM7eLx+fFtk7KucPtj2XhlI5xIk0JJ4dA0='
WHERE
key_id = 'bea278678b02cb4b0674c1305cdc2733e6f1f3414ba2869ba8dfb2131ebf6df9'
AND (
token = '1UxIpg8uBbM7eLx+fFtk7KucPtj2XhlI5xIk0JJ4dA0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)