UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D9FWvVG5h47HSGaiiSHwWORvRA7g5mWDDAHlgUbCZHY='
WHERE
key_id = '2a15d2c3a18c79d59e43c6deb5f0ea2a024bd864f6865ed6f790f53657ff3a82'
AND (
token = 'D9FWvVG5h47HSGaiiSHwWORvRA7g5mWDDAHlgUbCZHY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)