UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'IL1j5fBskuJJYe34mL0+VAdl4QNqKyHDpQ15uDcEZ0U=' 
WHERE 
  key_id = '10a5848b20803dd30a46d65a4d4b8bea1a4f415d7d8931cd2611fd7d4fe8ea75' 
  AND (
    token = 'IL1j5fBskuJJYe34mL0+VAdl4QNqKyHDpQ15uDcEZ0U=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00041