UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5+bPWEaPjYiiqk5RLyjHv1BSX6Yw+hvxrZ2k96KESeI='
WHERE
key_id = 'a7eb6f0b0960d3bc4462719a505bc993046f7959a2c3b8490fcad2de3ff4cf92'
AND (
token = '5+bPWEaPjYiiqk5RLyjHv1BSX6Yw+hvxrZ2k96KESeI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)