UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P8KN7SOV3LuVf+uqlV7e54RuxJxPLGSl0AeM2FXQtzw='
WHERE
key_id = 'b1b86d5341c3fd2ef9cd923465d793f16d2a576a6489b0f6c6b559d199449be1'
AND (
token = 'P8KN7SOV3LuVf+uqlV7e54RuxJxPLGSl0AeM2FXQtzw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)