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