UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'iVqMez2vefBPwimTTxoPXXcoyzEGI9nyNpgC4veIjwI=' 
WHERE 
  key_id = '555afafb0e8a2c19afce5dd88e0a3ce753b22eb1d7dd2bb0d508b9b8eacf9d5c' 
  AND (
    token = 'iVqMez2vefBPwimTTxoPXXcoyzEGI9nyNpgC4veIjwI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00025