UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JyR3opcIpU7LxZvXMOtigLhqpwauGP1d2TrD+/q+ZX4='
WHERE
key_id = '5ca7f036c91f24fdea6eca797335a18df0e07eac7cf3489fab338f85ee789eab'
AND (
token = 'JyR3opcIpU7LxZvXMOtigLhqpwauGP1d2TrD+/q+ZX4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)