UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'x47QqNIqnfDA9sqZ8AxXP7+KhnbaX9Mze03wSpX+tKg='
WHERE
key_id = '803f7c434f3e05ab6299203b364cc8423c359e30fab219ecb309054de49aa34e'
AND (
token = 'x47QqNIqnfDA9sqZ8AxXP7+KhnbaX9Mze03wSpX+tKg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)