UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0NMg2ULklNFCVRvu3CMlEo5ZS7iwNnV6+ffIIA7rrR8='
WHERE
key_id = 'a9e6547c29276b2fb16b781bae7b29e9db25e57c67049af879fea832ddffe285'
AND (
token = '0NMg2ULklNFCVRvu3CMlEo5ZS7iwNnV6+ffIIA7rrR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)