UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XLNy/ts3YiZYe63LZSx+XqjreGPLC5I7blzZlsMkVlU='
WHERE
key_id = '404813e6977283e3873fba62b562f95335a8d888fa617f1aff9d6f553711ff69'
AND (
token = 'XLNy/ts3YiZYe63LZSx+XqjreGPLC5I7blzZlsMkVlU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)