UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'sPQhUwcbXd2TDMwUJquf/3/IHUmo4Nw8UVCWBjDirF4='
WHERE
key_id = '46e406fb38a551662c8cfecc28cc656ab6d6b13520034aace58b1c144054b329'
AND (
token = 'sPQhUwcbXd2TDMwUJquf/3/IHUmo4Nw8UVCWBjDirF4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)