UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'lcGzRIFCGMFuQThExq+6AjDJ71yTFnUVcyLuByDNQoI='
WHERE
key_id = 'c93cf0c08a014ef544c659f10d41844c2fd8706a7c5db20e6075208b387a66d9'
AND (
token = 'lcGzRIFCGMFuQThExq+6AjDJ71yTFnUVcyLuByDNQoI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)