UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'Bukez2hXyFiUhe34JbS9GKrb+MVJvx6pQH7CqbMbjCk=' 
WHERE 
  key_id = 'ab59244805443e5e4b03f070d2189aa28bd374101b3237626d20844d97eee53f' 
  AND (
    token = 'Bukez2hXyFiUhe34JbS9GKrb+MVJvx6pQH7CqbMbjCk=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032