UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bZ3ZQxykwz+0Q0Qe6G750x7n9zBwErX0WRbHbuHjjS4='
WHERE
key_id = '97012e17a2c992156917c7449882fa96dc0a29914b0df27cc5e88fd8e2fca2a7'
AND (
token = 'bZ3ZQxykwz+0Q0Qe6G750x7n9zBwErX0WRbHbuHjjS4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)