UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BGcVPIe+xTMl50p3m8FlFaBYq+vpSoenv68S3MjMp+E='
WHERE
key_id = '9cea87692e628e4e932fad29ab8b36e772e68af17a83b900b3064991ed286166'
AND (
token = 'BGcVPIe+xTMl50p3m8FlFaBYq+vpSoenv68S3MjMp+E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)