UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VzFQUL15EhVCdfOA0tE9INOHe2xEwqKYTw5qIrcJSNI='
WHERE
key_id = 'fe7a3f53ac8a3d9bea7bb1ad87ff33dbc8992ac42346f8a57086875d0b375bd9'
AND (
token = 'VzFQUL15EhVCdfOA0tE9INOHe2xEwqKYTw5qIrcJSNI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)