UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sotsWDnqROPstyEw44F+pzctchdIIFZM7J+YtJVpZFw='
WHERE
key_id = '07ecdec62ff01ee2d4e0682b6122fbf13103d17e17f22402d3c34e1decc036cc'
AND (
token = 'sotsWDnqROPstyEw44F+pzctchdIIFZM7J+YtJVpZFw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)