UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'g6WIwh4TI8jCfC5sDPPGLBtK/tissFsz1+++5YV+W9k='
WHERE
key_id = '7fadafa976aecc335ce7341ac8f6e05e60e0575ee22f993ec029b896ac9ad93e'
AND (
token = 'g6WIwh4TI8jCfC5sDPPGLBtK/tissFsz1+++5YV+W9k='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)